﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ZipCodeDataSet" targetNamespace="http://tempuri.org/ZipCodeDataSet.xsd" xmlns:mstns="http://tempuri.org/ZipCodeDataSet.xsd" xmlns="http://tempuri.org/ZipCodeDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="dnbTestConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="dnbTestConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DnBDataCollector.My.MySettings.GlobalReference.Default.dnbTestConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ZipTableTableAdapter" GeneratorDataComponentClassName="ZipTableTableAdapter" Name="ZipTable" UserDataComponentName="ZipTableTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="Bizname.dbo.us_zip1" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        US_zip1.*
FROM            US_zip1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" />
              <Mapping SourceColumn="Offset" DataSetColumn="Offset" />
              <Mapping SourceColumn="TotalHits" DataSetColumn="TotalHits" />
              <Mapping SourceColumn="ZipID" DataSetColumn="ZipID" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="ExtractDate" DataSetColumn="ExtractDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="Bizname.dbo.us_zip1" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataZipData" GetMethodModifier="Public" GetMethodName="GetDataZipData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataZipData" UserSourceName="GetDataZipData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT TOP (1) City, ExtractDate, Offset, State, TotalHits, ZipCode, ZipID FROM us_zip1 WHERE (Offset IS NULL) OR (Offset = 0) OR (Offset &lt; TotalHits)
and zipcode like @zipcode</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="zipcode" ColumnName="ZipCode" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="nchar(5)" DbType="String" Direction="Input" ParameterName="@zipcode" Precision="0" ProviderType="NChar" Scale="0" Size="5" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateLastTry" Modifier="Public" Name="UpdateLastTry" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateLastTry">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       us_zip1
SET                ExtractDate = @extractDate
WHERE        (ZipCode = @zipcode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="extractDate" ColumnName="ExtractDate" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@extractDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ExtractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="zipcode" ColumnName="ZipCode" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="nchar(5)" DbType="String" Direction="Input" ParameterName="@zipcode" Precision="0" ProviderType="NChar" Scale="0" Size="5" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="dnbTestConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateZipTable" Modifier="Public" Name="UpdateZipTable" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateZipTable">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       us_zip1
SET                Offset = @Offset, TotalHits = @TotalHits, extractDate=@extractDate
WHERE        (ZipCode = @zipcode)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Offset" ColumnName="Offset" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Offset" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Offset" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="TotalHits" ColumnName="TotalHits" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@TotalHits" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="TotalHits" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="extractDate" ColumnName="ExtractDate" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="smalldatetime" DbType="DateTime" Direction="Input" ParameterName="@extractDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ExtractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="zipcode" ColumnName="ZipCode" DataSourceName="Bizname.dbo.us_zip1" DataTypeServer="nchar(5)" DbType="String" Direction="Input" ParameterName="@zipcode" Precision="0" ProviderType="NChar" Scale="0" Size="5" SourceColumn="ZipCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ZipCodeDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="ZipCodeDataSet" msprop:Generator_UserDSName="ZipCodeDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ZipTable" msprop:Generator_TableClassName="ZipTableDataTable" msprop:Generator_TableVarName="tableZipTable" msprop:Generator_TablePropName="ZipTable" msprop:Generator_RowDeletingName="ZipTableRowDeleting" msprop:Generator_UserTableName="ZipTable" msprop:Generator_RowChangingName="ZipTableRowChanging" msprop:Generator_RowEvHandlerName="ZipTableRowChangeEventHandler" msprop:Generator_RowDeletedName="ZipTableRowDeleted" msprop:Generator_RowEvArgName="ZipTableRowChangeEvent" msprop:Generator_RowChangedName="ZipTableRowChanged" msprop:Generator_RowClassName="ZipTableRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ZipCode" msprop:Generator_ColumnVarNameInTable="columnZipCode" msprop:Generator_ColumnPropNameInRow="ZipCode" msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" msprop:Generator_UserColumnName="ZipCode" type="xs:int" minOccurs="0" />
              <xs:element name="Offset" msprop:Generator_ColumnVarNameInTable="columnOffset" msprop:Generator_ColumnPropNameInRow="Offset" msprop:Generator_ColumnPropNameInTable="OffsetColumn" msprop:Generator_UserColumnName="Offset" type="xs:int" minOccurs="0" />
              <xs:element name="TotalHits" msprop:Generator_ColumnVarNameInTable="columnTotalHits" msprop:Generator_ColumnPropNameInRow="TotalHits" msprop:Generator_ColumnPropNameInTable="TotalHitsColumn" msprop:Generator_UserColumnName="TotalHits" type="xs:int" minOccurs="0" />
              <xs:element name="ZipID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnZipID" msprop:Generator_ColumnPropNameInRow="ZipID" msprop:Generator_ColumnPropNameInTable="ZipIDColumn" msprop:Generator_UserColumnName="ZipID" type="xs:int" />
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnPropNameInTable="StateColumn" msprop:Generator_UserColumnName="State" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ExtractDate" msprop:Generator_ColumnVarNameInTable="columnExtractDate" msprop:Generator_ColumnPropNameInRow="ExtractDate" msprop:Generator_ColumnPropNameInTable="ExtractDateColumn" msprop:Generator_UserColumnName="ExtractDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>